package cn.lanqiao.demo.dao;

import cn.lanqiao.demo.vo.StudentVaccineVo;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface VaccineDao {


    //查询接种多少剂列表
    @Select("select s.Sno,s.Sname,s.Cname,s.Sage,s.Sbirth,s.Ssex,v.inoculated from student s LEFT JOIN vaccine v on Vno = Sno where inoculated = #{inoculated}")
    public List<StudentVaccineVo> getInoculated(int inoculated);


    @Select("select count(1) from vaccine where inoculated = #{inoculated}")
    public Integer getCount(Integer inoculated);
}
